﻿SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE GetUserByEmail 
	-- Add the parameters for the stored procedure here
	@Mail nvarchar(255)
AS
BEGIN
	IF(@Mail IS NULL)
	BEGIN
		return 1
	END
	
	IF(LEN(@Mail)=0)
	BEGIN
		return 1
	END
	
    -- Insert statements for procedure here
	SELECT * FROM [LaRoquita].[dbo].[User]
	WHERE mail=@Mail
END
GO